RCG Oracle EBS Customers System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| CommonTools | This module provides utility functions and mappings for Customer transformations |
| create-customer-account-bo-request | Create Customer Account in Oracle EBS request mapping The CREATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to create the Customer Account in Oracle EBS. Maps CIM Customer to the input request that is used to consume the CREATE_CUST_ACCT_V2_BO Operation of the CREATE_CUST_ACCT_V2_BO PL/SQL API. |
| create-organization-bo-request | Create Organization Bussiness Object in Oracle EBS request mapping The CREATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to create the Customer in Oracle EBS. Maps CIM Customer to the input request that is used to consume the CREATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API. |
| create-person-bo-request | |
| extract-Ids-from-created-organization-bo | |
| extract-Ids-from-created-person-bo | Mapping to Extract PartySite IDs (BillTo and ShipTo), Parent object ID and Parent Object Type from the response of CREATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API. This information is used to create a Customer Account and associate it with the parent party and it's party site objects |
| extract-ids-from-organization-bo | Map to extract existing Party Site, Location, Email and Phone IDs from the Organization Business Object in Oracle EBS. This information is used to update the Email, Phone and Address information of an existing Organization. |
| extract-ids-from-person-bo | Map to extract existing Party Site, Location, Email and Phone IDs from the Person Business Object in Oracle EBS. This information is used to update the Email, Phone and Address information of an existing Person. |
| extract-partysite-ids-from-updated-organization-bo | Map to extract existing Party Site IDs from the updated Organization Business Object in Oracle EBS. This information is used to update the associated Customer Account object. |
| extract-partysite-ids-from-updated-person-bo | Map to extract existing Party Site IDs from the updated Person Business Object in Oracle EBS. This information is used to update the associated Customer Account object. |
| get-customer-acct-bo-request | Map to retrieve a Customer Account from Oracle EBS. The GET_CUST_ACCT_BO operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to retrieve the Customer information from Oracle EBS |
| get-organization-bo-request | Map to retrieve Organization Bussiness object from Oracle EBS. The GET_ORGANIZATION_BO operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to retrieve the Organization information from Oracle EBS |
| get-organization-bo-response | Retrieve Customer (Party as Organization) mapping. The GET_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to retrieve the Customer (Party as Organization) from Oracle EBS. Maps GET_ORGANIZATION_BO response to CIM Customer. |
| get-person-bo-request | Map to retrieve Person Bussiness object from Oracle EBS. The GET_PERSON_BO operation of the HZ_PERSON_BO_PUB PL/SQL API is used to retrieve the Person information from Oracle EBS |
| get-person-bo-response | Retrieve Customer (Party as Individual) mapping. The GET_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API is used to retrieve the Customer Account (Party as Individual) from Oracle EBS. Maps GET_PERSON_BO response to CIM Customer. |
| get-updated-organization-bo-response | Retrieve Organization from Oracle EBS mapping. |
| get-updated-person-bo-response | Retrieve Person from Oracle EBS mapping. |
| update-customer-account-request | Update Customer Account mapping. The UPDATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to Update the Customer Account in Oracle EBS. Maps CIM Customer to the input request that is used to consume the UPDATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API. |
| update-organization-bo-request | Update Oraganization Mapping The UPDATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to create the Customer in Oracle EBS. Maps CIM Customer to the input request that is used to consume the UPDATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API. |
| update-person-bo-request | Update Person Mapping The UPDATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API is used to Update the Person in Oracle EBS. Maps CIM Customer to the input request that is used to consume the UPDATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API. |
CommonTools
This module provides utility functions and mappings for Customer transformations
Source:
./src/main/resources/dwl/CommonTools.dwl
Variables
var ISOCountryCodesMap
This map includes the ISO 3166-1 alpha-2 code for countries
Functions
fun getFormattedDateTime (toFormat)
Formats the date-time to the type accepted by CIM
fun getTerritoryCodeForCountryName (countryName)
Maps Country Name to ISO 3166-1 alpha-2 code. Default value is "US"
return ISO 3166-1 alpha-2 code
fun getGlobalId (externalIdsArr)
This function filters ExternalIds with ExternalId Type as MDM and returns the first one
return Global ExternalID
fun getEmailAddressArr (contactPoints)
This function gets the EmailAddress from ContactPoint Array
fun getPrimaryEmailAddress (contactPoints)
This function returns the Primary EmailAddress
fun getPhoneArr (contactPoints)
This function gets the Phone from ContactPoint Array
fun getPrimaryPhone (contactPoints)
This function returns the Primary Contact Point Phone
fun updateAddressArr (contactPoints)
This function sets default value for isUsedForBilling flag in the ContactPointAddress array and returns the updated array
fun getShippingAddressArr (contactPoints)
This function filters addresses with isUsedForBilling flag as false
fun getShippingAddress (contactPoints)
This function gets the MailingAddress from Addresses array
fun getBillingAddress (contactPoints)
Filter Address with isUsedForBilling as true and return the first record
fun getCIMPartyObj (partyObj, partyId, partyType, emailObj, phoneObj, billingAddressObj, shippingAddressObj)
Function to return the CIM Party object with mapped values.
return Party Object type
fun getOraclePartySiteObjsItem (billingAddress, partySiteBillToId, billToLocationId, shippingAddress, partySiteShipToId, shipToLocationId)
Function to return the Oracle PartySite object with CIM mapped values.
return PartySite Object type
fun getOraclePhoneObjsItem (phoneObj, existingPhoneId)
Function to return the Oracle Phone object with CIM mapped values.
return PhoneObjectItem type
fun getOracleEmailObjsItem (emailObj, existingEmailId)
Function to return the Oracle Email object with CIM mapped values.
return EmailObjectItem type
fun getOracleCustomerAccountSiteObjsItem (partySiteBillTo, custAcctSiteBillToId, partySiteShipTo, custAcctSiteShipToId)
Function to return the Oracle PartySite object with CIM mapped values.
return PartySite Object type
create-customer-account-bo-request
Create Customer Account in Oracle EBS request mapping
The CREATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to create the Customer Account in Oracle EBS.
Maps CIM Customer to the input request that is used to consume the CREATE_CUST_ACCT_V2_BO Operation of the CREATE_CUST_ACCT_V2_BO PL/SQL API.
Source:
./src/main/resources/dwl/create-customer-account-bo-request.dwl
Mapping Tables
| CREATE_CUST_ACCT_V2_BO Request | CIM | Description | |
|---|---|---|---|
| P_CUST_ACCT_V2_OBJ.ATTRIBUTE20 | globalCustomerId | The Global Customer Id of the Customer. | |
| P_CUST_ACCT_V2_OBJ.ACCOUNT_NAME | accountName | The name of the Customer Account. | |
| P_CUST_ACCT_V2_OBJ.CUST_ACCT_SITE_OBJS | The Customer Account Site Objects to specify the BillTo and ShipTo Address types. | ||
| P_CUST_ACCT_V2_OBJ.P_CREATED_BY_MODULE | "TCA_V2_API" | The Created by module | set as "TCA_V2_API". |
| PX_PARENT_ID | Parent Object Id | The Oracle EBS identifier of the Party Object. This would be the Person or Organization Business Object identifier. | |
| PX_PARENT_OBJ_TYPE | Parent Object Type | The type of the Parent Party Type. It is set as either "PERSON" or "ORG" based on the Party Type |
create-organization-bo-request
Create Organization Bussiness Object in Oracle EBS request mapping
The CREATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to create the Customer in Oracle EBS.
Maps CIM Customer to the input request that is used to consume the CREATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API.
Source:
./src/main/resources/dwl/create-organization-bo-request.dwl
Mapping Tables
| CREATE_ORGANIZATION_BO Request | CIM | Description | |
|---|---|---|---|
| P_ORGANIZATION_OBJ.ORGANIZATION_NAME | party.name | The Name of the Organization. | |
| P_ORGANIZATION_OBJ.PARTY_SITE_OBJS | Party Site Objects | ContactPointAddress mapped to Party Site Objects in Oracle EBS. | |
| P_ORGANIZATION_OBJ.PHONE_OBJS | ContactPointPhone | ContactPointPhone mapped to Organization Phone Object in Oracle EBS. | |
| P_ORGANIZATION_OBJ.EMAIL_OBJS | ContactPointEmail | ContactPointEmail mapped to Organization Email Object in Oracle EBS. | |
| P_CREATED_BY_MODULE | "TCA_V2_API" | The Created by module | set as "TCA_V2_API". |
| P_RETURN_OBJ_FLAG | "T" | Flag to specify whether to return the created Organization Bussiness Object. Set as "T" i.e true. |
create-person-bo-request
Source:
./src/main/resources/dwl/create-person-bo-request.dwl
Mapping Tables
| CREATE_PERSON_BO Request | CIM | Description | |
|---|---|---|---|
| P_PERSON_OBJ.SALUTATION | party.salutation | Salutation of the Customer. | |
| P_PERSON_OBJ.PERSON_FIRST_NAME | party.firstName | Firstname of the Customer. | |
| P_PERSON_OBJ.PERSON_LAST_NAME | party.lastName | Lastname of the Customer. | |
| P_PERSON_OBJ.DATE_OF_BIRTH | party.birthDate | Birthdate of the Customer. | |
| P_PERSON_OBJ.PARTY_SITE_OBJS | Party Site Objects | ContactPointAddress mapped to Party Site Objects in Oracle EBS. | |
| P_PERSON_OBJ.PHONE_OBJS | ContactPointPhone | ContactPointPhone mapped to Organization Phone Object in Oracle EBS. | |
| P_PERSON_OBJ.EMAIL_OBJS | ContactPointEmail | ContactPointEmail mapped to Organization Email Object in Oracle EBS. | |
| P_CREATED_BY_MODULE | "TCA_V2_API" | The Created by module | set as "TCA_V2_API". |
| P_RETURN_OBJ_FLAG | "T" | Flag to specify whether to return the created Person Bussiness Object. Set as "T" i.e true. |
extract-Ids-from-created-organization-bo
Source:
./src/main/resources/dwl/extract-Ids-from-created-organization-bo.dwl
extract-Ids-from-created-person-bo
Mapping to Extract PartySite IDs (BillTo and ShipTo), Parent object ID and Parent Object Type from the response of CREATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API.
This information is used to create a Customer Account and associate it with the parent party and it's party site objects
Source:
./src/main/resources/dwl/extract-Ids-from-created-person-bo.dwl
extract-ids-from-organization-bo
Map to extract existing Party Site, Location, Email and Phone IDs from the Organization Business Object in Oracle EBS.
This information is used to update the Email, Phone and Address information of an existing Organization.
Source:
./src/main/resources/dwl/extract-ids-from-organization-bo.dwl
extract-ids-from-person-bo
Map to extract existing Party Site, Location, Email and Phone IDs from the Person Business Object in Oracle EBS.
This information is used to update the Email, Phone and Address information of an existing Person.
Source:
./src/main/resources/dwl/extract-ids-from-person-bo.dwl
extract-partysite-ids-from-updated-organization-bo
Map to extract existing Party Site IDs from the updated Organization Business Object in Oracle EBS.
This information is used to update the associated Customer Account object.
Source:
./src/main/resources/dwl/extract-partysite-ids-from-updated-organization-bo.dwl
extract-partysite-ids-from-updated-person-bo
Map to extract existing Party Site IDs from the updated Person Business Object in Oracle EBS.
This information is used to update the associated Customer Account object.
Source:
./src/main/resources/dwl/extract-partysite-ids-from-updated-person-bo.dwl
get-customer-acct-bo-request
Map to retrieve a Customer Account from Oracle EBS.
The GET_CUST_ACCT_BO operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to retrieve the Customer information from Oracle EBS
Source:
./src/main/resources/dwl/get-customer-acct-bo-request.dwl
get-organization-bo-request
Map to retrieve Organization Bussiness object from Oracle EBS.
The GET_ORGANIZATION_BO operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to retrieve the Organization information from Oracle EBS
Source:
./src/main/resources/dwl/get-organization-bo-request.dwl
get-organization-bo-response
Retrieve Customer (Party as Organization) mapping.
The GET_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to retrieve the Customer (Party as Organization) from Oracle EBS.
Maps GET_ORGANIZATION_BO response to CIM Customer.
Source:
./src/main/resources/dwl/get-organization-bo-response.dwl
Mapping Tables
| CIM | GET_ORGANIZATION_BO Response | Description |
|---|---|---|
| id | Customer Account Id | Identifier of the Customer Account associated with the Party in Oracle EBS . |
| partyRoleType | "Customer" | Set as "Customer". |
| customerStatus | "Active" | Set as "Active". |
| Start Party Mapping | ||
| id | id | The Id of the Party in Oracle EBS |
| partyType | "Organization" | Party Type set as "Organization" |
| party.name | X_ORGANIZATION_OBJ.ORGANIZATION_NAME | The name of the Organization |
| The LOCATION_OBJ of the PARTY_SITE_OBJS for which the SITE_USE_TYPE is BILL_TO is set as billingAddressObj | ||
| contactPointType | ContactPointAddress | Set as "ContactPointAddress" |
| id | BillingAddressObj.LOCATION_ID | The Identifier of the Billing Address Location |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| addressLine1 | BillingAddressObj.ADDRESS1 | The Address Line1 of the Billing Address Location |
| cityName | billingAddressObj.CITY | The City of the Billing Address Location |
| postalCodeText | billingAddressObj.POSTAL_CODE | The customer mailing postal code |
| stateProvinceName | billingAddressObj.STATE | The customer state province name |
| countryName | billingAddressObj.COUNTRY | The customer country name |
| isUsedForBilling | true | Set as "true" |
| primaryFlag | true | Set as "true" |
| The LOCATION_OBJ of the PARTY_SITE_OBJS for which the SITE_USE_TYPE is SHIP_TO is set as shippingAddressObj | ||
| contactPointType | ContactPointAddress | Set as "ContactPointAddress" |
| id | shippingAddressObj.LOCATION_ID | The Identifier of the Billing Address Location |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| addressLine1 | shippingAddressObj.ADDRESS1 | The Address Line1 of the Shipping Address Location |
| cityName | shippingAddressObj.CITY | The City of the Shipping Address Location |
| postalCodeText | shippingAddressObj.POSTAL_CODE | The customer shipping postal code |
| stateProvinceName | shippingAddressObj.STATE | The customer state province name |
| countryName | shippingAddressObj.COUNTRY | The customer country name |
| The PHONE_OBJS for which the PRIMARY_FLAG is "Y" is set as the phoneObj | ||
| id | phoneObj.PHONE_ID | The identifier of the Phone Object in Oracle EBS |
| telephoneNumber | phoneObj.RAW_PHONE_NUMBER | The Phone number of the Customer |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| contactPointType | ContactPointPhone | Set as "ContactPointPhone" |
| The EMAIL_OBJS for which the PRIMARY_FLAG is "Y" is set as the emailObj | ||
| id | emailObj.EMAIL_ID | The identifier of the Email Object in Oracle EBS |
| emailAddress | emailObj.EMAIL_ADDRESS | The Phone number of the Customer |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| contactPointType | ContactPointEmail | Set as "ContactPointEmail" |
| End Party Mapping | ||
| externalIds.id | id | Id field set as null |
| externalIds.externalId | Global_Customer_Id__c | The customer Global ID |
| externalIds.externalIdType | MDM | The customer is hardcoded as MDM |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
get-person-bo-request
Map to retrieve Person Bussiness object from Oracle EBS.
The GET_PERSON_BO operation of the HZ_PERSON_BO_PUB PL/SQL API is used to retrieve the Person information from Oracle EBS
Source:
./src/main/resources/dwl/get-person-bo-request.dwl
get-person-bo-response
Retrieve Customer (Party as Individual) mapping.
The GET_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API is used to retrieve the Customer Account (Party as Individual) from Oracle EBS.
Maps GET_PERSON_BO response to CIM Customer.
Source:
./src/main/resources/dwl/get-person-bo-response.dwl
Mapping Tables
| CIM | GET_PERSON_BO Response | Description |
|---|---|---|
| id | Customer Account Id | Identifier of the Customer Account associated with the Party in Oracle EBS . |
| partyRoleType | "Customer" | Set as "Customer". |
| customerStatus | "Active" | Set as "Active". |
| Start Party Mapping | ||
| id | id | The Id of the Party in Oracle EBS |
| partyType | "Individual" | Party Type set as "Individual" |
| party.firstName | X_PERSON_OBJ.PERSON_FIRST_NAME | The first name of the Person |
| party.lastName | X_PERSON_OBJ.PERSON_LAST_NAME | The last name of the Person |
| party.birthDate | X_PERSON_OBJ.DATE_OF_BIRTH | The Date of birth of the Person |
| The LOCATION_OBJ of the PARTY_SITE_OBJS for which the SITE_USE_TYPE is BILL_TO is set as billingAddressObj | ||
| contactPointType | ContactPointAddress | Set as "ContactPointAddress" |
| id | BillingAddressObj.LOCATION_ID | The Identifier of the Billing Address Location |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| addressLine1 | BillingAddressObj.ADDRESS1 | The Address Line1 of the Billing Address Location |
| cityName | billingAddressObj.CITY | The City of the Billing Address Location |
| postalCodeText | billingAddressObj.POSTAL_CODE | The customer mailing postal code |
| stateProvinceName | billingAddressObj.STATE | The customer state province name |
| countryName | billingAddressObj.COUNTRY | The customer country name |
| isUsedForBilling | true | Set as "true" |
| primaryFlag | true | Set as "true" |
| The LOCATION_OBJ of the PARTY_SITE_OBJS for which the SITE_USE_TYPE is SHIP_TO is set as shippingAddressObj | ||
| contactPointType | ContactPointAddress | Set as "ContactPointAddress" |
| id | shippingAddressObj.LOCATION_ID | The Identifier of the Billing Address Location |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| addressLine1 | shippingAddressObj.ADDRESS1 | The Address Line1 of the Shipping Address Location |
| cityName | shippingAddressObj.CITY | The City of the Shipping Address Location |
| postalCodeText | shippingAddressObj.POSTAL_CODE | The customer shipping postal code |
| stateProvinceName | shippingAddressObj.STATE | The customer state province name |
| countryName | shippingAddressObj.COUNTRY | The customer country name |
| The PHONE_OBJS for which the PRIMARY_FLAG is "Y" is set as the phoneObj | ||
| id | phoneObj.PHONE_ID | The identifier of the Phone Object in Oracle EBS |
| telephoneNumber | phoneObj.RAW_PHONE_NUMBER | The Phone number of the Customer |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| contactPointType | ContactPointPhone | Set as "ContactPointPhone" |
| The EMAIL_OBJS for which the PRIMARY_FLAG is "Y" is set as the emailObj | ||
| id | emailObj.EMAIL_ID | The identifier of the Email Object in Oracle EBS |
| emailAddress | emailObj.EMAIL_ADDRESS | The Phone number of the Customer |
| activeFromDate | now() | The date from which the contactpoint is active. Set as now() |
| contactPointType | ContactPointEmail | Set as "ContactPointEmail" |
| End Party Mapping | ||
| externalIds.id | id | Id field set as null |
| externalIds.externalId | Global_Customer_Id__c | The customer Global ID |
| externalIds.externalIdType | MDM | The customer is hardcoded as MDM |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
get-updated-organization-bo-response
Retrieve Organization from Oracle EBS mapping.
Source:
./src/main/resources/dwl/get-updated-organization-bo-response.dwl
get-updated-person-bo-response
Retrieve Person from Oracle EBS mapping.
Source:
./src/main/resources/dwl/get-updated-person-bo-response.dwl
update-customer-account-request
Update Customer Account mapping.
The UPDATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API is used to Update the Customer Account in Oracle EBS.
Maps CIM Customer to the input request that is used to consume the UPDATE_CUST_ACCT_V2_BO Operation of the HZ_CUST_ACCT_BO_PUB PL/SQL API.
Source:
./src/main/resources/dwl/update-customer-account-request.dwl
update-organization-bo-request
Update Oraganization Mapping
The UPDATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API is used to create the Customer in Oracle EBS.
Maps CIM Customer to the input request that is used to consume the UPDATE_ORGANIZATION_BO Operation of the HZ_ORGANIZATION_BO_PUB PL/SQL API.
Source:
./src/main/resources/dwl/update-organization-bo-request.dwl
Mapping Tables
| UPDATE_ORGANIZATION_BO Request | CIM | Description | |
|---|---|---|---|
| P_ORGANIZATION_OBJ.ORGANIZATION_ID | partyId | The Id of the Organization in Oracle EBS. | |
| P_ORGANIZATION_OBJ.ORGANIZATION_NAME | party.name | The Name of the Organization | |
| P_ORGANIZATION_OBJ.PARTY_SITE_OBJS | Party Site Objects | ContactPointAddress mapped to Party Site Objects in Oracle EBS. | |
| P_ORGANIZATION_OBJ.PHONE_OBJS | ContactPointPhone | ContactPointPhone mapped to Organization Phone Object in Oracle EBS. | |
| P_ORGANIZATION_OBJ.EMAIL_OBJS | ContactPointEmail | ContactPointEmail mapped to Organization Email Object in Oracle EBS. | |
| P_CREATED_BY_MODULE | "TCA_V2_API" | The Created by module | set as "TCA_V2_API". |
| P_RETURN_OBJ_FLAG | "T" | Flag to specify whether to return the created Organization Bussiness Object. Set as "T" i.e true. |
update-person-bo-request
Update Person Mapping
The UPDATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API is used to Update the Person in Oracle EBS.
Maps CIM Customer to the input request that is used to consume the UPDATE_PERSON_BO Operation of the HZ_PERSON_BO_PUB PL/SQL API.
Source:
./src/main/resources/dwl/update-person-bo-request.dwl
Mapping Tables
| UPDATE_PERSON_BO Request | CIM | Description | |
|---|---|---|---|
| P_PERSON_OBJ.PERSON_ID | party ID | The identifier of the Person in Oracle EBS. | |
| P_PERSON_OBJ.SALUTATION | party.salutation | Salutation of the Person. | |
| P_PERSON_OBJ.PERSON_FIRST_NAME | party.firstName | Firstname of the Person. | |
| P_PERSON_OBJ.PERSON_LAST_NAME | party.lastName | Lastname of the Person. | |
| P_PERSON_OBJ.DATE_OF_BIRTH | party.birthDate | Birthdate of the Person. | |
| P_PERSON_OBJ.PARTY_SITE_OBJS | Party Site Objects | ContactPointAddress mapped to Party Site Objects in Oracle EBS. | |
| P_PERSON_OBJ.PHONE_OBJS | ContactPointPhone | ContactPointPhone mapped to Organization Phone Object in Oracle EBS. | |
| P_PERSON_OBJ.EMAIL_OBJS | ContactPointEmail | ContactPointEmail mapped to Organization Email Object in Oracle EBS. | |
| P_CREATED_BY_MODULE | "TCA_V2_API" | The Created by module | set as "TCA_V2_API". |
| P_RETURN_OBJ_FLAG | "T" | Flag to specify whether to return the created Person Bussiness Object. Set as "T" i.e true. |